SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vweSolicitudes
AS
SELECT     idSolicitud AS Id, Alumno, Fecha, TipoSolicitud, Cantidad, Urgencia, FechaInicio, FechaFin, Observaciones, idLineaDeByP
FROM         dbo.tb_Solicitudes
GO
GRANT SELECT ON  [dbo].[vweSolicitudes] TO [Becas]
GRANT INSERT ON  [dbo].[vweSolicitudes] TO [Becas]
GRANT DELETE ON  [dbo].[vweSolicitudes] TO [Becas]
GRANT UPDATE ON  [dbo].[vweSolicitudes] TO [Becas]
GRANT SELECT ON  [dbo].[vweSolicitudes] TO [SoloVer]
GO
